========================================================================= Date: Tue, 16 Feb 1993 12:22:26 EST Reply-To: "Microsoft Access Database Discussion List" Sender: "Microsoft Access Database Discussion List" From: "NATHAN BRINDLE" Subject: columns in reports? OK, I love the Report Wizard, but how do I get a report that prints on only half the page to print in two columns? It looks like the report would fit quite well but I don't see how to do that. Any ideas? I hate wasting all that paper.... ========================================================================= Date: Tue, 16 Feb 1993 12:29:10 EST Reply-To: "Microsoft Access Database Discussion List" Sender: "Microsoft Access Database Discussion List" From: "NATHAN BRINDLE" Subject: Oops... Sorry...I just found it under the Setup button in Preview...It's not a good day here. :) ========================================================================= Date: Tue, 16 Feb 1993 10:07:22 PDT Reply-To: "Microsoft Access Database Discussion List" Sender: "Microsoft Access Database Discussion List" From: "Mark Barnet (Business Enter. Syst. Tech)" Subject: RE: columns in reports? Use SETUP when displaying the report (not in design mode). Select MORE button, and specify 2 or more columns per page, then format the layout of those colmns (vertical or horizontal or ...). Then you'll get two columns. ---------- |From: "NATHAN BRINDLE" |To: Multiple recipients of list ACCESS-L |Subject: columns in reports? |Date: Tuesday, February 16, 1993 12:22PM | |OK, I love the Report Wizard, but how do I get a report that prints on |only half the page to print in two columns? It looks like the report |would fit quite well but I don't see how to do that. Any ideas? I |hate wasting all that paper.... | |-----------------------------------------------------BITNET: NBRINDLE@INDYCMS |Nathan C. Brindle, Student Activities Office |Staff Advisor, ALPHA PHI OMEGA, TAU OMICRON CHAPTER |Indiana University-Purdue University at Indianapolis |Internet: NBRINDLE@INDYCMS.IUPUI.EDU or NBRINDLE@INDYVAX.IUPUI.EDU |Compu$erve: 71461.2471@COMPUSERVE.COM |------------------------------------------------------------------------------ | | ========================================================================= Date: Tue, 16 Feb 1993 16:04:00 PST Reply-To: "Microsoft Access Database Discussion List" Sender: "Microsoft Access Database Discussion List" From: Schwenke@MAILGATE.WIWI.UNI-MARBURG.DE Subject: What's up? Hi there, isn't there anything to discuss? I am looking for some applications written in Access because I want to see the ability of that program. Is there an ftp-site where I can download some applications? What about the rumours that there are some bugs in Access? I programmed a lot in dBase and Clipper (up to dbase IV 1.1 and Clipper 5.0) and my first impression of Access is that live is much easier now. But: Did anyone test some megs of datas? What about the speed? Let's discuss or this list will die very soon. Greetings Detlef Schwenke E-Mail: Schwenke@DMRHRZ11.bitnet or Philipps-University Marburg Schwenke@Mailgate.Wiwi.Uni-Marburg.De Universitaetsstr. 25 Phone: +49-06421-283748 W-3550 Marburg Fax: +49-06421-284858 Germany ========================================================================= Date: Tue, 16 Feb 1993 16:04:03 EST Reply-To: "Microsoft Access Database Discussion List" Sender: "Microsoft Access Database Discussion List" From: "NATHAN BRINDLE" Subject: Re: What's up? In-Reply-To: Message of Tue, 16 Feb 1993 16:04:00 PST from Thanks for your concern about the list, but it's less than a week old, and I don't intend to let it die anytime soon...:) I am currently running three major, unrelated (to each other) databases in Access, but since I'm still learning what it's capable of, I don't have anything of major importance to report. I programmed extensively in dBase IV 1.5 until I got thorougly sick of it. Access popped up at a very good time for me. I love the ease of creating queries and forms and reports. Things I didn't have the energy to code in dBase have become a few minutes' worth of work in Access. It seems to me that this is a product with great potential. I'll let others deal with reported bugs--I have not noticed any (yet). Nathan Brindle Listowner, ACCESS-L@INDYCMS -----------------------------------------------------BITNET: NBRINDLE@INDYCMS Nathan C. Brindle, Student Activities Office Staff Advisor, ALPHA PHI OMEGA, TAU OMICRON CHAPTER Indiana University-Purdue University at Indianapolis Internet: NBRINDLE@INDYCMS.IUPUI.EDU or NBRINDLE@INDYVAX.IUPUI.EDU Compu$erve: 71461.2471@COMPUSERVE.COM ------------------------------------------------------------------------------ ========================================================================= Date: Tue, 16 Feb 1993 11:45:00 HST Reply-To: "Microsoft Access Database Discussion List" Sender: "Microsoft Access Database Discussion List" From: "Michael E. Macmillan" Subject: Re: What's up? >I'll let others deal with reported bugs--I have not noticed any (yet). Bugs there are, but how important they are probably depends on what you do. There is an official list in the MSACCESS forum on CompuServe and probably on the Microsoft electronic bulletin board system. Michael E. Macmillan (macmillm@ewc) ========================================================================= Date: Tue, 16 Feb 1993 17:23:04 -0500 Reply-To: "Microsoft Access Database Discussion List" Sender: "Microsoft Access Database Discussion List" From: J BOWDEN Subject: Re: What's up? what is the current cost of ACCESS? I tried to get my parents to get it for me for christmas - but they couldn't find a copy to buy. what is it running for now? jim iijq500@indyvax.iupui.edu ========================================================================= Date: Tue, 16 Feb 1993 19:42:14 EST Reply-To: "Microsoft Access Database Discussion List" Sender: "Microsoft Access Database Discussion List" From: George Waller Subject: Making a PC map Can anyone figure out how to do the following using ACCESS? I want to keep an inventory of PCs with the usual fields for type, serial#, warranty expiration date. That is simple enough, but I would also like to map their location. For example: :-------------------------------------------------------------: : PC01 : : Warr: 3-7-93 PC03 : : ID#: Z44832 Warr: 2-22-87 : : PC02 ID#: G33492 : : Warr: 3-7-93 : : ID#: Z89832 : :-------------------------------------------------------------: There would be other info of a textual nature such as department name, lines for walls. Any ideas out there? ------------------------------------------------------------------------ George Waller, Microcomputer Consultant, Homer Babbidge Library U-5MS University of Connecticut, Storrs CT 06269-1005 203-486-5260 Internet: hbladm47@uconnvm.uconn.edu Bitnet: HBLADM47@UCONNVM.BITNET ------------------------------------------------------------------------ ========================================================================= Date: Wed, 17 Feb 1993 08:44:16 EST Reply-To: "Microsoft Access Database Discussion List" Sender: "Microsoft Access Database Discussion List" Comments: Resent-From: NATHAN BRINDLE Comments: Originally-From: Revised List Processor (1.7e) From: "NATHAN BRINDLE" Subject: ACCESS-L: error report from MSU The following message was sent to me as an error. I have reposted it for those who will be interested. The problem was that the mail software on the user's machine copies the header of the forwarded message as well as the body of the message of the new message. This will always cause an error and the message will not be distributed. If your mail software formats forwarded messages this way, you may not want to use forwards with LISTSERV. --Nathan Brindle, listowner >>From: "David.Martell" >>Subject: Re: What's up? I was selling for $99 until early January as special offer retail. I believe the normal retail is $259. I have not seen an educational discounted price yet. I will be waiting for that price before I purchase. I have signed up to this list to see some interaction from those of you that actually now using it. ***Forwarded Message Ends*** -----------------------------------------------------BITNET: NBRINDLE@INDYCMS Nathan C. Brindle, Student Activities Office Staff Advisor, ALPHA PHI OMEGA, TAU OMICRON CHAPTER List Owner, STUACTS@INDYCMS, APOSEC52@INDYCMS, and ACCESS-L@INDYCMS Indiana University-Purdue University at Indianapolis Internet: NBRINDLE@INDYCMS.IUPUI.EDU or NBRINDLE@INDYVAX.IUPUI.EDU ------------------------------------------------------------------------------ ========================================================================= Date: Wed, 17 Feb 1993 09:13:48 -0600 Reply-To: brh@arlan.byu.edu Sender: "Microsoft Access Database Discussion List" From: "Bill R. Holman" Subject: Separating data and application Could someone tell me how to port tables from one application space to another. I am developing new forms, queries, and reports on my computer which is independant of the others. Meanwhile that which I have already completed is already in use, meaning that they have been doing tremendous amounts of data entry. When I try and copy the newest revision of forms, queries, and reports to disk and then to their computers it also forces me to copy the data as it existed on my machine, losing all revisions that they had made since my last change. Up until now I have had to cut and paste tables from their db to the new one I install but this seems like a work-around. There has to be a better way...I hope all this made sense...any help would be appreciated. Bill Holman BRH@arlan.byu.edu Brigham Young University ========================================================================= Date: Wed, 17 Feb 1993 09:43:00 PST Reply-To: "Microsoft Access Database Discussion List" Sender: "Microsoft Access Database Discussion List" From: Schwenke@MAILGATE.WIWI.UNI-MARBURG.DE Subject: AW: Making a PC map >Can anyone figure out how to do the following using ACCESS? I want >to keep an inventory of PCs with the usual fields for type, serial#, >warranty expiration date. We are planning to do just the same thing. >to map their location. For example: > >:-------------------------------------------------------------: >: PC01 : >: Warr: 3-7-93 PC03 : >: ID#: Z44832 Warr: 2-22-87 : >: PC02 ID#: G33492 : >: Warr: 3-7-93 : >: ID#: Z89832 : >:-------------------------------------------------------------: I think that it is possible to archive PCX-pictures too. Why don't you make a PCX and put it into your application. Not the best solution, I know but maybe a way to try out. >------------------------------------------------------------------------ >George Waller, Microcomputer Consultant, Homer Babbidge Library U-5MS >University of Connecticut, Storrs CT 06269-1005 203-486-5260 >Internet: hbladm47@uconnvm.uconn.edu Bitnet: HBLADM47@UCONNVM.BITNET >------------------------------------------------------------------------ Another thing: I have seen some guys from Microsoft subscribed to this list. Can we hope that our hints on improving MS-Access will be forwarded to the developers? When will the Runtime-Module be released (and when will it be released in Germany)? Greetings Detlef Schwenke E-Mail: Schwenke@DMRHRZ11.bitnet or Philipps-University Marburg Schwenke@Mailgate.Wiwi.Uni-Marburg.De Universitaetsstr. 25 Phone: +49-06421-283748 W-3550 Marburg Fax: +49-06421-284858 Germany ========================================================================= Date: Wed, 17 Feb 1993 19:30:00 GMT Reply-To: "Microsoft Access Database Discussion List" Sender: "Microsoft Access Database Discussion List" From: Clare Love <0005794946@MCIMAIL.COM> Subject: re. Making a PC map George Waller asks: >Can anyone figure out how to do the following using ACCESS? I want >to keep an inventory of PCs with the usual fields for type, serial#, >warranty expiration date. That is simple enough, but I would also like >to map their location. For example: > >:-------------------------------------------------------------: >: PC01 : >: Warr: 3-7-93 PC03 : >: ID#: Z44832 Warr: 2-22-87 : >: PC02 ID#: G33492 : >: Warr: 3-7-93 : >: ID#: Z89832 : >:-------------------------------------------------------------: > >There would be other info of a textual nature such as >department name, lines for walls. Any ideas out there? > >------------------------------------------------------------------------ >George Waller, Microcomputer Consultant, Homer Babbidge Library U-5MS >University of Connecticut, Storrs CT 06269-1005 203-486-5260 >Internet: hbladm47@uconnvm.uconn.edu Bitnet: HBLADM47@UCONNVM.BITNET >------------------------------------------------------------------------ > I have little experience with ACCESS, but it appears that ACCESS itself is not going to provide the graphic capabilities you require. It looks as though you need to link ACCESS up with some tool such as AutoCAD to do things right. Perhaps someone more knowledgable than I can clue us in on how to go about this. I too have applications where I need to combine database, and drawing capabilities... not just a link to a bitmap graphic snapshot. Can someone explain the proper relationship between ACCESS, and Visual BASIC? Perhaps the solution lies there. Clare Love (206) 533-3484 579-4946@MCIMail.com ========================================================================= Date: Wed, 17 Feb 1993 14:39:35 EST Reply-To: "Microsoft Access Database Discussion List" Sender: "Microsoft Access Database Discussion List" From: George Waller Subject: Re: AW: Making a PC map In-Reply-To: Message of Wed, 17 Feb 1993 09:43:00 PST from On Wed, 17 Feb 1993 09:43:00 PST said: >>Can anyone figure out how to do the following using ACCESS? I want >>to keep an inventory of PCs with the usual fields for type, serial#, >>warranty expiration date. > >We are planning to do just the same thing. > > >I think that it is possible to archive PCX-pictures too. Why don't you make >a PCX and put it into your application. Not the best solution, I know but >maybe a way to try out. >Detlef Schwenke E-Mail: Schwenke@DMRHRZ11.bitnet or Thanks Detlef, I did start trying out the following: Create a form with a subform. The form has a Paintbrush file showing a map of the department and other fields about the department. The subform will have the info about the PCs in a tabular format. On the "map" there will be an abbreviation for the PC which will point to the details in the subform. Not exactly the way I wanted to do it, but close enough. Thanks, George. ------------------------------------------------------------------------ George Waller, Microcomputer Consultant, Homer Babbidge Library U-5MS University of Connecticut, Storrs CT 06269-1005 203-486-5260 Internet: hbladm47@uconnvm.uconn.edu Bitnet: HBLADM47@UCONNVM.BITNET ------------------------------------------------------------------------ ========================================================================= Date: Wed, 17 Feb 1993 15:40:18 PST Reply-To: "Microsoft Access Database Discussion List" Sender: "Microsoft Access Database Discussion List" From: "Ray Porrata" Subject: RE: AW: Making a PC map Is there a way that this location be placed on a grid like mapping(ie: setting up a grid of buttons with dialogs attached to them)? Also take a look at the PSet Method. I'll leave it from there for you to play with. Good Luck Ray :-) ========================================================================= Date: Wed, 17 Feb 1993 15:35:25 PST Reply-To: "Microsoft Access Database Discussion List" Sender: "Microsoft Access Database Discussion List" Comments: E: RFC822 "local part" (username) containing a blank was encountered. These usernames are not presently supported. From: Undetermined origin c/o Postmaster Subject: RE: AW: Making a PC map Is there a way that this location be placed on a grid like map? Also take a look at the PSet Method. I'll leave it from there for you to play with. Good Luck Ray :-) ---------- From: To: Multiple recipients of list ACCESS-L Subject: AW: Making a PC map Date: Wednesday, February 17, 1993 9:43AM >Can anyone figure out how to do the following using ACCESS? I want >to keep an inventory of PCs with the usual fields for type, serial#, >warranty expiration date. We are planning to do just the same thing. >to map their location. For example: > >:-------------------------------------------------------------: >: PC01 : >: Warr: 3-7-93 PC03 : >: ID#: Z44832 Warr: 2-22-87 : >: PC02 ID#: G33492 : >: Warr: 3-7-93 : >: ID#: Z89832 : >:-------------------------------------------------------------: I think that it is possible to archive PCX-pictures too. Why don't you make a PCX and put it into your application. Not the best solution, I know but maybe a way to try out. >------------------------------------------------------------------------ >George Waller, Microcomputer Consultant, Homer Babbidge Library U-5MS >University of Connecticut, Storrs CT 06269-1005 203-486-5260 >Internet: hbladm47@uconnvm.uconn.edu Bitnet: HBLADM47@UCONNVM.BITNET >------------------------------------------------------------------------ Another thing: I have seen some guys from Microsoft subscribed to this list. Can we hope that our hints on improving MS-Access will be forwarded to the developers? When will the Runtime-Module be released (and when will it be released in Germany)? Greetings Detlef Schwenke E-Mail: Schwenke@DMRHRZ11.bitnet or Philipps-University Marburg Schwenke@Mailgate.Wiwi.Uni-Marburg.De Universitaetsstr. 25 Phone: +49-06421-283748 W-3550 Marburg Fax: +49-06421-284858 Germany ========================================================================= Date: Wed, 17 Feb 1993 20:42:51 EST Reply-To: "Microsoft Access Database Discussion List" Sender: "Microsoft Access Database Discussion List" From: Chris Allison Subject: How do I subset a data field? I have an account code field in my database which I need to subset. I can not figure out a way to tell ACCESS to split one field into (in this case) 5 new fields. Anyone know how to solve this? ----- Chris Allison Miami University 137 Hoyt Hall Bitnet : Chris@miamiu.bitnet Oxford OH. 45056 Usenet : Chris@miamiu.acs.muohio.edu ========================================================================= Date: Wed, 17 Feb 1993 20:58:00 CST Reply-To: "Microsoft Access Database Discussion List" Sender: "Microsoft Access Database Discussion List" From: "Jeffrey M. Gipson" Subject: Re: How do I subset a data field? > I have an account code field in my database which I need to subset. I can >not figure out a way to tell ACCESS to split one field into (in this case) 5 >new fields. Anyone know how to solve this? > ----- Chris Allison > Miami University > 137 Hoyt Hall Bitnet : Chris@miamiu.bitnet > Oxford OH. 45056 Usenet : Chris@miamiu.acs.muohio.edu I had a similar problem with a text field that contained social security numbers that I wanted to divide into three separate fields. What I did was to create the new fields and then designed an update query to parse the original field and update the relavent information in the new ones. -J. M. Gipson ---------------------------------------------------------------------------- J. M. Gipson GIPSON@KNOX.BITNET Knox College Box 418 Galesburg, IL 61401 ========================================================================= Date: Thu, 18 Feb 1993 09:33:00 PST Reply-To: "Microsoft Access Database Discussion List" Sender: "Microsoft Access Database Discussion List" From: Schwenke@MAILGATE.WIWI.UNI-MARBURG.DE Subject: AW: Separating data and application >Could someone tell me how to port tables from one application space >to another. I am developing new forms, queries, and reports on my >computer which is independant of the others. Meanwhile that which I >have already completed is already in use, meaning that they have been >doing tremendous amounts of data entry. When I try and copy the >newest revision of forms, queries, and reports to disk and then to >their computers it also forces me to copy the data as it existed on >my machine, losing all revisions that they had made since my last >change. Hi Bill, do I understand it right that you do not really to port the tables but that you want to update the forms, queries and reports on some computers? If it's that you want to do you can do it simply with cut and paste too. Just open the mdb-file with the new form or querie on the computer you want to port your form/query to. Then copy your form/query into the clipboard and close the file. Open the file you want to port it to and activate the form or query-view (button). Insert the form/query. If you don't have created new objects or manipulated the table-structure, it should work. I tried it and it worked well. >Up until now I have had to cut and paste tables from their db to the >new one I install but this seems like a work-around. There has to be >a better way...I hope all this made sense...any help would be >appreciated. I aggree that it can be useful (Hi, Microsoft) to implement a feature to export/import a form/query seperately. Detlef Schwenke E-Mail: Schwenke@DMRHRZ11.bitnet or Philipps-University Marburg Schwenke@Mailgate.Wiwi.Uni-Marburg.De Universitaetsstr. 25 Phone: +49-06421-283748 W-3550 Marburg Fax: +49-06421-284858 Germany ========================================================================= Date: Fri, 19 Feb 1993 10:53:24 EST Reply-To: "Microsoft Access Database Discussion List" Sender: "Microsoft Access Database Discussion List" From: "NATHAN BRINDLE" Subject: leaving command button out of tab order I know I know how to do this, but I can't figure it out. How do I keep a command button from getting the focus, or keeping it out of the tab order? I don't want a user to accidentally hit return on this button and thereby run the related macro--I want the user to have to push the button with the mouse or hit the Alt-key assigned. Thanks for help...:) -----------------------------------------------------BITNET: NBRINDLE@INDYCMS Nathan C. Brindle, Student Activities Office Indiana University Purdue University Indianapolis Staff Advisor, ALPHA PHI OMEGA, TAU OMICRON CHAPTER List Owner, STUACTS@INDYCMS, APOSEC52@INDYCMS, and ACCESS-L@INDYCMS Internet: NBRINDLE@INDYCMS.IUPUI.EDU or NBRINDLE@INDYVAX.IUPUI.EDU ------------------------------------------------------------------------------ ========================================================================= Date: Mon, 22 Feb 1993 16:26:28 -0500 Reply-To: "Microsoft Access Database Discussion List" Sender: "Microsoft Access Database Discussion List" From: Pekka Koskinen CIMO Subject: Sorting tables I've been wondering if there is an easy way to sort the records to a RANDOM order? (just don't ask why I want to do it...) Does anyone know how to do it (without writing a long application)? Thanks in advance! Pekka :) :) :) :) :) :) :) :) :) :) :) :) :) :) :) :) :) :) :) :) :) :) :) Pekka Koskinen ! CIMO ! Life is transitory. Rather like tel +358-(9)0-7747 7962 ! a sparrow flying through a mead hall. fax +358-(9)0-7747 7064 ! (translation of an Old English Proverb) ========================================================================= Date: Mon, 22 Feb 1993 13:54:43 -0600 Reply-To: "Microsoft Access Database Discussion List" Sender: "Microsoft Access Database Discussion List" From: MARK TURPIN Subject: RE: Sorting tables Try This.... 1. Create a random table primary key random number 2. Link the random table to the table you want to sort in random order by primay keys one-to-one relationship 3. sort random table by random number the output will now be in random order. ========================================================================= Date: Tue, 23 Feb 1993 09:41:08 -0500 Reply-To: "Microsoft Access Database Discussion List" Sender: "Microsoft Access Database Discussion List" From: Pekka Koskinen CIMO Subject: RE: Sorting tables to random order On 22 Feb 1993 13:54:43 -0600, MARK TURPIN wrote: >Try This.... > 1. Create a random table > primary key > random number > > 2. Link the random table to the table you want to sort in random order > by primay keys one-to-one relationship > > 3. sort random table by random number > the output will now be in random order. Makes sense to me, I will try it this way! Thanks a lot! Pekka :) :) :) :) :) :) :) :) :) :) :) :) :) :) :) :) :) :) :) :) :) :) :) Pekka Koskinen ! CIMO ! Life is transitory. Rather like tel +358-(9)0-7747 7962 ! a sparrow flying through a mead hall. fax +358-(9)0-7747 7064 ! (translation of an Old English Proverb) ========================================================================= Date: Tue, 23 Feb 1993 16:06:13 EST Reply-To: "Microsoft Access Database Discussion List" Sender: "Microsoft Access Database Discussion List" From: "NATHAN BRINDLE" Subject: Query query I'm running a select query based on a table that has fields containing Firstname, Middlename, and Lastname. What I want to do is create an expression field that would give me Firstname Middlename Lastname for the purpose of creating a list that looks relatively nice. The problem is that not all of the records in the table have a value for Middlename, and the select query just returns a blank. This is not the first time I've had this problem, but it's become sort of serious and I haven't been able to find the answer in the documentation (either that or I'm too dense to see it). Any help would be appreciated. -----------------------------------------------------BITNET: NBRINDLE@INDYCMS Nathan C. Brindle, Student Activities Office Indiana University Purdue University Indianapolis Staff Advisor, ALPHA PHI OMEGA, TAU OMICRON CHAPTER List Owner, STUACTS@INDYCMS, APOSEC52@INDYCMS, and ACCESS-L@INDYCMS Internet: NBRINDLE@INDYCMS.IUPUI.EDU or NBRINDLE@INDYVAX.IUPUI.EDU ------------------------------------------------------------------------------ ========================================================================= Date: Tue, 23 Feb 1993 15:42:04 CST Reply-To: ardie@ux1.cso.uiuc.edu Sender: "Microsoft Access Database Discussion List" From: "R. D. McClary" Subject: RE: Query query In Message Tue, 23 Feb 1993 16:06:13 EST, "NATHAN BRINDLE" writes: >I'm running a select query based on a table that has fields containing >Firstname, Middlename, and Lastname. What I want to do is create an >expression field that would give me Firstname Middlename Lastname for >the purpose of creating a list that looks relatively nice. The problem >is that not all of the records in the table have a value for Middlename, >and the select query just returns a blank. This is not the first time >I've had this problem, but it's become sort of serious and I haven't >been able to find the answer in the documentation (either that or I'm >too dense to see it). > >Any help would be appreciated. > >-----------------------------------------------------BITNET: NBRINDLE@INDYCMS >Nathan C. Brindle, Student Activities Office >Indiana University Purdue University Indianapolis >Staff Advisor, ALPHA PHI OMEGA, TAU OMICRON CHAPTER >List Owner, STUACTS@INDYCMS, APOSEC52@INDYCMS, and ACCESS-L@INDYCMS >Internet: NBRINDLE@INDYCMS.IUPUI.EDU or NBRINDLE@INDYVAX.IUPUI.EDU >------------------------------------------------------------------------------ I agree, the documentation can be a bit vague! Appendix C should have been bound separately. I think what you want would be on page 653. You search on a field - any field - but show only the calculated field. The "&" concatenates the field. There might be a way to compensate for the null in the middlename field, but this should give you something. (There will be, unfortunately, an extra large space between firstname and lastname.) ============================================================================ HELP!!! Is there any simple way to get Access to capitalize either the first letter in a text field or the first letter of each word? I can do that in a number of other databases, but Access seems to limit me to just ">" or "<". Thanks! [][][][][][][][][][][][][][][][][][][][][][][][][][][][][][][][][][][][][][][] /| [] ` o.O ' [] ardie@ux1.cso.uiuc.edu =(___)= [] R. D. McClary U [] Department of Plant Pathology ACK!THPTPHH! [] University of Illinois, Urbana-Champaign [][][][][][][][][][][][][][][][][][][][][][][][][][][][][][][][][][][][][][][] ========================================================================= Date: Tue, 23 Feb 1993 17:03:13 EST Reply-To: "Microsoft Access Database Discussion List" Sender: "Microsoft Access Database Discussion List" From: "NATHAN BRINDLE" Subject: RE: Query query In-Reply-To: Message of Tue, 23 Feb 1993 15:42:04 CST from Thank you thank you thank you! FirstName&" "&MiddleName&" "&LastName worked where FirstName+" "+MiddleName+ " "+LastName didn't. I think I see why. The plus acts as an AND operator and the & just concatenates strings. I can live with the extra space... Regards, -----------------------------------------------------BITNET: NBRINDLE@INDYCMS Nathan C. Brindle, Student Activities Office Indiana University Purdue University Indianapolis Staff Advisor, ALPHA PHI OMEGA, TAU OMICRON CHAPTER List Owner, STUACTS@INDYCMS, APOSEC52@INDYCMS, and ACCESS-L@INDYCMS Internet: NBRINDLE@INDYCMS.IUPUI.EDU or NBRINDLE@INDYVAX.IUPUI.EDU ------------------------------------------------------------------------------ ========================================================================= Date: Tue, 23 Feb 1993 14:07:26 -0800 Reply-To: "Microsoft Access Database Discussion List" Sender: "Microsoft Access Database Discussion List" From: "Chuck Catlett" Subject: Re: Query query In-Reply-To: Your message of Tue, 23 Feb 93 16:06:13 -0500. <9302232108.AA01832@cpl2.ns.nts.uci.edu> >> Date: Tue, 23 Feb 1993 16:06:13 EST >> To: Multiple recipients of list ACCESS-L >> From: "NATHAN BRINDLE" >> Subject: Query query >> >> I'm running a select query based on a table that has fields containing >> Firstname, Middlename, and Lastname. What I want to do is create an >> expression field that would give me Firstname Middlename Lastname for >> the purpose of creating a list that looks relatively nice. The problem >> is that not all of the records in the table have a value for Middlename, >> and the select query just returns a blank. This is not the first time >> I've had this problem, but it's become sort of serious and I haven't >> been able to find the answer in the documentation (either that or I'm >> too dense to see it). >> >> Any help would be appreciated. >> >> -----------------------------------------------------BITNET: NBRINDLE@INDYCM S >> Nathan C. Brindle, Student Activities Office >> Indiana University Purdue University Indianapolis >> Staff Advisor, ALPHA PHI OMEGA, TAU OMICRON CHAPTER >> List Owner, STUACTS@INDYCMS, APOSEC52@INDYCMS, and ACCESS-L@INDYCMS >> Internet: NBRINDLE@INDYCMS.IUPUI.EDU or NBRINDLE@INDYVAX.IUPUI.EDU >> ----------------------------------------------------------------------------- - See pages 484 and 485, Combining Text Values, in the User's Guide. It describes exactly what you want, I believe. (OK so I wasted an hour looking for that thing that I knew I'd seen somewhere in that damn documentation. Just don't tell anyone, ok?) ========================================================================= Date: Tue, 23 Feb 1993 22:30:38 CST Reply-To: "Microsoft Access Database Discussion List" Sender: "Microsoft Access Database Discussion List" From: "Msr. Brad Choate" Subject: RE: Query query >FirstName&" "&MiddleName&" "&LastName worked where FirstName+" "+MiddleName+ >" "+LastName didn't. I think I see why. The plus acts as an AND operator >and the & just concatenates strings. I can live with the extra space... You don't *have* to live with the extra space, though! There may be a better way, but what _I_ would do is this: RTrim$(FirstName&" "&MiddleName)&" "&LastName This would avoid the double space if the MiddleName field is blank. If there is a chance that FirstName could be blank, then the best expression (although not pretty) would be this: LTrim$(RTrim$(FirstName&" "&MiddleName)&" "&LastName) There. If there's a better way, feel free to let me know. I'm *always* open to ways of making life just a little bit easier! :) -Brad -- Disclaimer: I claim dis claim. Brad S. Choate choate@acs.harding.edu ========================================================================= Date: Tue, 23 Feb 1993 22:36:12 PST Reply-To: "Microsoft Access Database Discussion List" Sender: "Microsoft Access Database Discussion List" From: NSF SF Bay research projects Hello all: I, as everybody else, couldn't resist the $99 purchase price, so I bought a copy of Access. Now I want to find out really how useful this software is. I have built databases with SQL commands (well, er, actually QUEL, but that's another story) and want to use some of my queries in Access. Some of these are pages-long scripts of SQL commands; so, my question is this: Can I import these documents into Access and execute them? I know you can view and/or edit the SQL rendition of an Access query, but what I want is a little more ambitious, I want to import whole sequences of SQL commands from pre-existing files -- can this be done? I'd like to know your thoughts on this matter. Please post to the mail server or write to me directly Thank you, Howard Foster (nsf@ced.berkeley.edu) ========================================================================= Date: Wed, 24 Feb 1993 08:36:10 -0500 Reply-To: "Microsoft Access Database Discussion List" Sender: "Microsoft Access Database Discussion List" From: The Hole in the Wall Gang Subject: ECO '93...and MS-ACCESS Hello/Bonjour; I have just recieved a Registration card from ECO '93 (East Cost Oracle) User group announcing a Meeting 4-6, 1993 at the Philadelphia Hilton and Towers. Unfortunately, I will be unable to attend, and am hopeful that someone on this list will be attending. Three of the sessions have a "Just Added" flag against them; Microsoft Access ODBC Connection to Oracle, The New Client/Server API from Oracle New Technologies, and Client/Server Implementing Oracle Applications Network. Of course, these are the three I'm most curious about. If someone going could post an abstract of one or more of the sessions to this list or to my address I would appreciate recieving the information. Thank's in advance... Frank (Gid'day Marcia) ~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~ "The views expressed here are my own, not AECL Research Company." Frank C. Brown Voice: (613) 584-3311 6195 Business and Information Systems Fax: (613) 584-1224 Atomic Energy of Canada Ltd, Research Company Chalk River Laboratories Bitnet: BROWNF@CRL.AECL.BITNET Chalk River, Ontario, Canada Internet: BROWNF@CRL.AECL.CA K0J 1J0 ~~~~~~~~~~~~~~~~~~~~~~~~~~The Hole in the Wall Gang~~~~~~~~~~~~~~~~~~~~~~~~~~~ ~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~ ========================================================================= Date: Wed, 24 Feb 1993 07:45:24 PDT Reply-To: "Microsoft Access Database Discussion List" Sender: "Microsoft Access Database Discussion List" From: "Mark Barnet (Business Enter. Syst. Tech)" Subject: RE: In my experience of SQL products, Access type SQL is a non-standard version of SQL and most likely not at all compatable with QUEL brand of SQL statements. On top of this there is no facility in Access to do what you want to do apart from writing a module to do it for you. ---------- |From: NSF SF Bay research projects |To: Multiple recipients of list ACCESS-L |Date: Tuesday, February 23, 1993 10:36PM | |Hello all: | |I, as everybody else, couldn't resist the $99 purchase |price, so I bought a copy of Access. Now I want to find out |really how useful this software is. | |I have built databases with SQL commands (well, er, |actually QUEL, but that's another story) and want to use |some of my queries in Access. Some of these are pages-long |scripts of SQL commands; so, my question is this: Can I |import these documents into Access and execute them? I |know you can view and/or edit the SQL rendition of an |Access query, but what I want is a little more ambitious, I |want to import whole sequences of SQL commands from |pre-existing files -- can this be done? | |I'd like to know your thoughts on this matter. Please post |to the mail server or write to me directly | |Thank you, Howard Foster (nsf@ced.berkeley.edu) | | ========================================================================= Date: Wed, 24 Feb 1993 11:15:54 EST Reply-To: "Microsoft Access Database Discussion List" Sender: "Microsoft Access Database Discussion List" Comments: Resent-From: NATHAN BRINDLE Comments: Originally-From: Myles Leitch From: "NATHAN BRINDLE" This was sent directly to me, but I suspect it is really aimed at the list, so I am reposting it. I would like to participate in the ACCESS discussion group. We are using ACCESS in a linguistics project here at UBC. A first question that I have for anyone is the following: in a Table is there any way to specify a particular font for a particular field (column). It seems to be the case that in Table view, only one font per table is allowed. This is kind of messy since we are working with multiple fonts in many tables including phonetics characters and potentially non-roman scripts as well. Of course this is not a problem for FORMS or REPORTS. It is a problem for Tables and for Queries which use the Table type format. Anybody got any ideas on how to get round this? Myles Leitch *FORWARDED MESSAGE ENDS* -----------------------------------------------------BITNET: NBRINDLE@INDYCMS Nathan C. Brindle, Student Activities Office Indiana University Purdue University Indianapolis Staff Advisor, ALPHA PHI OMEGA, TAU OMICRON CHAPTER List Owner, STUACTS@INDYCMS, APOSEC52@INDYCMS, and ACCESS-L@INDYCMS Internet: NBRINDLE@INDYCMS.IUPUI.EDU or NBRINDLE@INDYVAX.IUPUI.EDU ------------------------------------------------------------------------------ ========================================================================= Date: Wed, 24 Feb 1993 11:35:06 -0500 Reply-To: "Microsoft Access Database Discussion List" Sender: "Microsoft Access Database Discussion List" From: KENTON HENSLEY 617-496-2131 Subject: Capitalizing first letters of words in a control I'm afraid your choice of formatting symbols does limit you to > and < - all characters upper or all lower case. You will have to code a function in access basic, passing it the contents of the control on a form, and using the string functions InStr() and UCase() to help you do what you want. Not as easy as one would like. Not like paradox which has a rich set of formatting symbols/functions. Kenton Hensley Harvard Law Library ========================================================================= Date: Wed, 24 Feb 1993 15:47:05 PST Reply-To: "Microsoft Access Database Discussion List" Sender: "Microsoft Access Database Discussion List" From: "Jonathan Lavigne" Subject: Exporting ASCII text from Access I was fairly impressed at how easily Access imports lengthy text fields. Unfortunately, I'm also rather dismayed at how difficult it is to get the same data out again in a form I can use with other programs. I have a table with several fields including one that contains help screens formatted only with carriage returns and one that contains the names of the screens. I'd like to be able to have Access save each screen in a separate file that has the same name as the screen name. It seems to me that, in dBase, I could have written a little program to do this sort of thing. I haven't yet found any way that promises to let me do it with Access, though I spent several hours leafing through the documentation. At the very least, I'd like to be able to get even a single comma-delimited file that includes only the screens and screen names. Even that seems impossible. Access will export the entire table, but it doesn't seem to let me choose which fields to include. It's all or nothing, as far as I can see. I got the OUTPUTAS.DLL file from CompuServe that is supposed to make it possible to save a report as ASCII text. Unfortunately, when I tried to make a report that included the field containing the screen text, I got an unhelpful message telling me the field didn't exist. This even though I dragged the field name onto the report form from the field list. (Is this a known bug, or do I need to do something to a memo field before I can use it in a report?) Even if I could define a proper report, it seems the DLL will write out only as much data from a field as I leave room for on the report form. Since the screen fields vary in length, this isn't very encouraging. What I ended up doing is exporting the table from Access as a dBase IV file. I then imported the dBase file into FileMaker Pro and used that program to produce the comma-delimited file I needed. Figuring out how to do it took about five minutes in FileMaker Pro. This solution works, but it's hardly satisfactory. Access seems severely limited in the choices it gives you for exporting data. Does anyone know of any better ways to get a comma-delimited file out of Access that doesn't include all the fields in a table and that doesn't depend on writing a report form? Jonathan Lavigne BL.JPL@RLG.STANFORD.EDU Research Libraries Group/Stanford University To: ACCESS-L@INDYCMS ========================================================================= Date: Wed, 24 Feb 1993 19:13:18 EST Reply-To: "Microsoft Access Database Discussion List" Sender: "Microsoft Access Database Discussion List" From: "NATHAN BRINDLE" Subject: Re: Exporting ASCII text from Access In-Reply-To: Message of Wed, 24 Feb 1993 15:47:05 PST from Just as something you might want to try...how about creating a query with the field data you want, writing that query to a table (I saw an option in one of the pull-downs, but I'm nowhere near my documentation), and then exporting the new table? Sorry for the limited specifics, but as I say, I'm nowhere near the manuals. HTH, -----------------------------------------------------BITNET: NBRINDLE@INDYCMS Nathan C. Brindle, Student Activities Office Indiana University Purdue University Indianapolis Staff Advisor, ALPHA PHI OMEGA, TAU OMICRON CHAPTER List Owner, STUACTS@INDYCMS, APOSEC52@INDYCMS, and ACCESS-L@INDYCMS Internet: NBRINDLE@INDYCMS.IUPUI.EDU or NBRINDLE@INDYVAX.IUPUI.EDU ------------------------------------------------------------------------------ ========================================================================= Date: Wed, 24 Feb 1993 16:27:20 PDT Reply-To: "Microsoft Access Database Discussion List" Sender: "Microsoft Access Database Discussion List" From: "Mark Barnet (Business Enter. Syst. Tech)" Subject: RE: Exporting ASCII text from Access Try making the field on the report expandable and contactable (properties: grow and shrink set to yes). The width of your field will still remain the same but the height (number of lines) will grow with the contents.You will also need to format this field to insert your quotes (chr$(34) ) and commas (",") in a combined string... like using: =chr$(34) & [field1] & chr$(34) & "," & chr$(34) & [field2] & chr$(34) Then print your report to an ascii file via the generic/text printer driver hooked to the FILE: device (simple Windows functionality here). I've done this and it works just fine on large non-memo character fields, should work for memo fields as well. Mark ---------- |From: "Jonathan Lavigne" |To: Multiple recipients of list ACCESS-L |Subject: Exporting ASCII text from Access |Date: Wednesday, February 24, 1993 3:47PM | |I was fairly impressed at how easily Access imports lengthy text |fields. Unfortunately, I'm also rather dismayed at how difficult |it is to get the same data out again in a form I can use with other |programs. | |I have a table with several fields including one that contains help |screens formatted only with carriage returns and one that contains |the names of the screens. I'd like to be able to have Access save |each screen in a separate file that has the same name as the screen |name. It seems to me that, in dBase, I could have written a little |program to do this sort of thing. I haven't yet found any way that |promises to let me do it with Access, though I spent several hours |leafing through the documentation. | |At the very least, I'd like to be able to get even a single |comma-delimited file that includes only the screens and screen |names. Even that seems impossible. Access will export the entire |table, but it doesn't seem to let me choose which fields to |include. It's all or nothing, as far as I can see. | |I got the OUTPUTAS.DLL file from CompuServe that is supposed to make |it possible to save a report as ASCII text. Unfortunately, when I |tried to make a report that included the field containing the screen |text, I got an unhelpful message telling me the field didn't exist. |This even though I dragged the field name onto the report form from |the field list. (Is this a known bug, or do I need to do something |to a memo field before I can use it in a report?) Even if I could |define a proper report, it seems the DLL will write out only as much |data from a field as I leave room for on the report form. Since the |screen fields vary in length, this isn't very encouraging. | |What I ended up doing is exporting the table from Access as a dBase |IV file. I then imported the dBase file into FileMaker Pro and used |that program to produce the comma-delimited file I needed. Figuring |out how to do it took about five minutes in FileMaker Pro. This |solution works, but it's hardly satisfactory. Access seems severely |limited in the choices it gives you for exporting data. Does anyone |know of any better ways to get a comma-delimited file out of Access |that doesn't include all the fields in a table and that doesn't |depend on writing a report form? | |Jonathan Lavigne BL.JPL@RLG.STANFORD.EDU |Research Libraries Group/Stanford University | |To: ACCESS-L@INDYCMS | | ========================================================================= Date: Thu, 25 Feb 1993 10:47:28 EST Reply-To: "Microsoft Access Database Discussion List" Sender: "Microsoft Access Database Discussion List" From: "NATHAN BRINDLE" Subject: comma-delimited Was someone having trouble yesterday exporting to comma-delimited files? I just did one for kicks and giggles and never saw anything so easy in my life. Choose Export and Delimited (Text), set a couple of options if need be, and away you go. Sorry if my memory is going... -----------------------------------------------------BITNET: NBRINDLE@INDYCMS Nathan C. Brindle, Student Activities Office Indiana University Purdue University Indianapolis Staff Advisor, ALPHA PHI OMEGA, TAU OMICRON CHAPTER List Owner, STUACTS@INDYCMS, APOSEC52@INDYCMS, and ACCESS-L@INDYCMS Internet: NBRINDLE@INDYCMS.IUPUI.EDU or NBRINDLE@INDYVAX.IUPUI.EDU ------------------------------------------------------------------------------ ========================================================================= Date: Thu, 25 Feb 1993 08:12:52 PDT Reply-To: "Microsoft Access Database Discussion List" Sender: "Microsoft Access Database Discussion List" From: "Mark Barnet (Business Enter. Syst. Tech)" Subject: RE: comma-delimited This solution works fine for exporting entire tables, but not queries or selected columns of a given table. ---------- |From: "NATHAN BRINDLE" |To: Multiple recipients of list ACCESS-L |Subject: comma-delimited |Date: Thursday, February 25, 1993 10:47AM | |Was someone having trouble yesterday exporting to comma-delimited files? |I just did one for kicks and giggles and never saw anything so easy in |my life. Choose Export and Delimited (Text), set a couple of options |if need be, and away you go. | |Sorry if my memory is going... | |-----------------------------------------------------BITNET: NBRINDLE@INDYCMS |Nathan C. Brindle, Student Activities Office |Indiana University Purdue University Indianapolis |Staff Advisor, ALPHA PHI OMEGA, TAU OMICRON CHAPTER |List Owner, STUACTS@INDYCMS, APOSEC52@INDYCMS, and ACCESS-L@INDYCMS |Internet: NBRINDLE@INDYCMS.IUPUI.EDU or NBRINDLE@INDYVAX.IUPUI.EDU |------------------------------------------------------------------------------ | | ========================================================================= Date: Thu, 25 Feb 1993 11:48:42 EST Reply-To: "Microsoft Access Database Discussion List" Sender: "Microsoft Access Database Discussion List" From: "NATHAN BRINDLE" Subject: RE: comma-delimited In-Reply-To: Message of Thu, 25 Feb 1993 08:12:52 PDT from Then you run a MAKE TABLE query, create a temporary table that way for use in exporting, and export. One extra step. -----------------------------------------------------BITNET: NBRINDLE@INDYCMS Nathan C. Brindle, Student Activities Office Indiana University Purdue University Indianapolis Staff Advisor, ALPHA PHI OMEGA, TAU OMICRON CHAPTER List Owner, STUACTS@INDYCMS, APOSEC52@INDYCMS, and ACCESS-L@INDYCMS Internet: NBRINDLE@INDYCMS.IUPUI.EDU or NBRINDLE@INDYVAX.IUPUI.EDU ------------------------------------------------------------------------------ ========================================================================= Date: Thu, 25 Feb 1993 17:07:36 -0500 Reply-To: "Microsoft Access Database Discussion List" Sender: "Microsoft Access Database Discussion List" From: KENTON HENSLEY 617-496-2131 Subject: Re: Exporting ASCII text from Access Nathan Brindles idea is dead on. Create a query with the fields you want in it. From the menu choose Query/Make Table. and you have a new table with just the right fields that you can export. Kenton Hensley Harvard Law Library ========================================================================= Date: Thu, 25 Feb 1993 12:13:55 -0800 Reply-To: robert@slipknot.rain.com Sender: "Microsoft Access Database Discussion List" From: robert@SLIPKNOT.RAIN.COM Subject: Re: Ascii reports Well, I've had a chance to try both methods for outputing ascii reports, and the generic printer/print to file option is definitely superior. It takes a little work to set up (I needed to find a version of tty.srv and tty.hlp-- they're on the last of the Windows 3.1 distribution disks) but it does all I expect it to do. In my case, I'm using the report to generate input to troff (which, among other things, allows me to print variable sized records in my phone book application). I've constructed an ABF to operate on each record, making invisible any controls which contain no data. In my test case, I needed to do some editing of the form to ensure a minimum spacing between fields, and to avoid a line concatenation problem I was having between records, and outputing the pages seemed a little slow on my 16MHz 386 machine, but I ended up with a file of 83968 bytes. However, having just installed outputas.dll, I tried outputing the same form using it. The print speed was noticably slower, the resulting file was 288768 bytes in size, and examination of the file revealed that outputas.dll bypasses the report events mechanism: every control was printed in every record, which probably accounts for some of the size increase and speed loss. So, if you don't have outputas.dll already, I'd recommend just installing the generic printer (which uses files you should already have), and does IMHO an all around better job of producing ascii reports. ________________________________________________________________________________ Robert Reed Home Animation Ltd. 503-656-8414 robert@slipknot.rain.com 5686 First Court, West Linn, OR 97068 Hawaii has always been a very pivotal role in the Pacific. It is in the Pacific. It is part of the United States that is an island that is right there. --Dan Quayle, speaking with reporters in Hawaii, May 1989 ________________________________________________________________________________ ========================================================================= Date: Thu, 25 Feb 1993 19:48:28 +0100 Reply-To: "Microsoft Access Database Discussion List" Sender: "Microsoft Access Database Discussion List" From: Detlef Kuepper Subject: RE: In-Reply-To: <9302241613.AA18043@inf-wiss.ivp.uni-konstanz.de> "Mark Barnet (Business Enter. Syst. Tech)" writes: > > In my experience of SQL products, Access type SQL is a non-standard > version of SQL and most likely not at all compatable with QUEL brand of > SQL statements. On top of this there is no facility in Access to do > what you want to do apart from writing a module to do it for you. I think SQL is standardized by ANSI. Does anybody know to what degree ACCESS supports this standard? Detlef Kuepper kuepper@inf-wiss.ivp.uni-konstanz.de ========================================================================= Date: Fri, 26 Feb 1993 11:41:01 -0500 Reply-To: "Microsoft Access Database Discussion List" Sender: "Microsoft Access Database Discussion List" From: prevo@BLOT.KSC.NASA.GOV Subject: Re: In-Reply-To: Your message of "Thu, 25 Feb 93 19:48:28 +0100." >> I think SQL is standardized by ANSI. Does anybody know to what degree >> ACCESS supports this standard? >> >> Detlef Kuepper kuepper@inf-wiss.ivp.uni-konstanz.de I thought the book went into pretty good detail on that. I bought the ANSI spec and there is an awful lot of "vendor-dependent" wording in the spec itself. So you can easily have an SQL implementation that is ANSI compliant but not portable. Besides, standards are great because there's so many to choose from! Joe Prevo prevo@blot.ksc.nasa.gov ========================================================================= Date: Fri, 26 Feb 1993 12:59:33 EST Reply-To: "Microsoft Access Database Discussion List" Sender: "Microsoft Access Database Discussion List" From: George Waller Subject: Column widths This is no doubt right in the documentation, but could someone please tell me: 1. How to save column widths in a query. 2. When using formwizard and specifying tabular form, default spaces are left between the fields. I would like no spaces between the fields so the form looks more like a data entry sheet. Thanks! ------------------------------------------------------------------------ George Waller, Microcomputer Consultant, Homer Babbidge Library U-5MS University of Connecticut, Storrs CT 06269-1005 203-486-5260 Internet: hbladm47@uconnvm.uconn.edu Bitnet: HBLADM47@UCONNVM.BITNET ------------------------------------------------------------------------ ========================================================================= Date: Fri, 26 Feb 1993 13:19:18 EST Reply-To: "Microsoft Access Database Discussion List" Sender: "Microsoft Access Database Discussion List" Comments: Resent-From: NATHAN BRINDLE Comments: Originally-From: George Waller Comments: Warning -- original Sender: tag was ACCESS-L@INDYCMS From: "NATHAN BRINDLE" Subject: Column widths >This is no doubt right in the documentation, but could someone >please tell me: > >1. How to save column widths in a query. This appears to be a function of what you've set them to in the table(s) you're basing the query on. There isn't a Save Layout option in the File menu in Query view. >2. When using formwizard and specifying tabular form, default spaces > are left between the fields. I would like no spaces between the fields > so the form looks more like a data entry sheet. I suspect that the answer to this is to shift to Design View and change things to fit what you want. I don't recall any way to change the FW defaults, but (as always) I could be wrong.... -----------------------------------------------------BITNET: NBRINDLE@INDYCMS Nathan C. Brindle, Student Activities Office Indiana University Purdue University Indianapolis Staff Advisor, ALPHA PHI OMEGA, TAU OMICRON CHAPTER List Owner, STUACTS@INDYCMS, APOSEC52@INDYCMS, and ACCESS-L@INDYCMS Internet: NBRINDLE@INDYCMS.IUPUI.EDU or NBRINDLE@INDYVAX.IUPUI.EDU ------------------------------------------------------------------------------ ========================================================================= Date: Fri, 26 Feb 1993 15:15:56 CST Reply-To: mikem@ns.apertus.com Sender: "Microsoft Access Database Discussion List" From: Mike Miller Subject: Nested queries Anyone know how to make this happen in Access... SELECT X FROM A WHERE X NOT IN ( SELECT X FROM B); mj -- Michaeljon Miller mikem@ns.apertus.com Apertus Technologies 612-828-0161 / 612-860-2181 7275 Flying Cloud Drive Eden Prairie, MN 55344 ========================================================================= Date: Fri, 26 Feb 1993 14:59:22 PST Reply-To: "Microsoft Access Database Discussion List" Sender: "Microsoft Access Database Discussion List" From: NSF SF Bay research projects >From: Mike Miller >Subject: Nested queries >Anyone know how to make this happen in Access... > >SELECT X FROM A > WHERE X NOT IN > ( SELECT X FROM B); > >mj The following is inelegent but is easy to understand .... In QUEL this is: retrieve into X ( A.all ) delete X where X.key = B.key So in SQL this is something like (excuse my syntax) SELECT X FROM A DELETE FROM A WHERE A.key IN (SELECT B.key FROM B) -Howard (nsf@ced.berkeley.edu) PS Hey! How about an asnswer to my SQL question -- about importing long SQL queries into ACCESS. Is it possible? ========================================================================= Date: Fri, 26 Feb 1993 15:10:04 PST Reply-To: "Microsoft Access Database Discussion List" Sender: "Microsoft Access Database Discussion List" From: hchin@SFU.CA Subject: Tab move sequence in Form. In-Reply-To: <9302261958.AA25918@whistler.sfu.ca>; from "George Waller" at Feb 26, 93 12:59 pm Greetings! How do you assign the sequence of control field movement in which the cursor is going to go when a TAB key is hit. It seems to be depending on the sequence you inserted the field while designing the form...any help? and ..thanks in advance... Fred Chin internet: hchin@sfu.ca bitnet: hchin@sfuvax.bitnet ========================================================================= Date: Fri, 26 Feb 1993 18:36:55 -0500 Reply-To: "Microsoft Access Database Discussion List" Sender: "Microsoft Access Database Discussion List" From: George Raudabaugh Subject: Nested Queries >>From: Mike Miller >>Subject: Nested queries >>Anyone know how to make this happen in Access... >> >>SELECT X FROM A >> WHERE X NOT IN >> ( SELECT X FROM B); >> >>mj > >The following is inelegent but is easy to understand >.... > >In QUEL this is: > > retrieve into X ( > A.all > ) > delete X where X.key = B.key > >So in SQL this is something like (excuse my syntax) > > SELECT X FROM A > DELETE FROM A > WHERE A.key IN > (SELECT B.key FROM B) > > >-Howard (nsf@ced.berkeley.edu) > >PS Hey! How about an asnswer to my SQL question -- >about importing long SQL queries into ACCESS. Is >it possible? I found subselects (or nested queries or whatever) impossible to use in Access. Even hacking the view SQL text window caused errors. Howard, you can try importing SQL queries through pasting into the view SQL text window or try making them query objects in access basic I think. I haven't messed with this (or access) recently so am not sure. gr. -- George Raudabaugh Manager/Document Technologies Information Dimensions, Inc. raudabaugh@idicl1.idi.battelle.org (work email) 5080 Tuttle Crossing Blvd. Dublin, Ohio 43017 (614) 761-7309 (voice mail) ========================================================================= Date: Fri, 26 Feb 1993 18:47:21 EST Reply-To: "Microsoft Access Database Discussion List" Sender: "Microsoft Access Database Discussion List" From: "NATHAN BRINDLE" Subject: Re: Tab move sequence in Form. In-Reply-To: Message of Fri, 26 Feb 1993 15:10:04 PST from Yes, go to the Edit menu while in Form Design and choose the last option, Tab Order. That will bring up a dialog box that allows you to switch things around. HOWEVER...one thing it do is let you leave something OUT of the Tab order completely, such as a command button. Does anyone have any ideas on how to accomplish that? I'm at a loss. -----------------------------------------------------BITNET: NBRINDLE@INDYCMS Nathan C. Brindle, Student Activities Office Indiana University Purdue University Indianapolis Staff Advisor, ALPHA PHI OMEGA, TAU OMICRON CHAPTER List Owner, STUACTS@INDYCMS, APOSEC52@INDYCMS, and ACCESS-L@INDYCMS Internet: NBRINDLE@INDYCMS.IUPUI.EDU or NBRINDLE@INDYVAX.IUPUI.EDU ------------------------------------------------------------------------------ ========================================================================= Date: Fri, 26 Feb 1993 16:32:46 -0800 Reply-To: robert@slipknot.rain.com Sender: "Microsoft Access Database Discussion List" Comments: E: RFC822 "local part" (username) containing a blank was encountered. These usernames are not presently supported. From: Undetermined origin c/o Postmaster Subject: Re: Tab move sequence in Form. In-Reply-To: Your message of Fri, 26 Feb 93 18:47:21 -0500. NBRINDLE%INDYCMS.BITNET@pucc.Princeton.EDU writes: |Yes, go to the Edit menu while in Form Design and choose the last option, |Tab Order. That will bring up a dialog box that allows you to switch |things around. | |HOWEVER...one thing it do is let you leave something OUT of the |Tab order completely, such as a command button. Does anyone have any |ideas on how to accomplish that? I'm at a loss. I just did a little be of exploring that today, but I don't think you're going to like the answer. There appears to be two properties that remove a control from the tab order, but both have side effects: Visible does it, but makes the control invisible. Select also does it, but makes the control unselectable. So far I haven't found any other way. So, are other people coming to the conclusion that MS Access is a hodged together POS like I am? ________________________________________________________________________________ Robert Reed Home Animation Ltd. 503-656-8414 robert@slipknot.rain.com 5686 First Court, West Linn, OR 97068 I had never regarded writing software as a legitimate profession. It was like writing poetry--admirable, but you couldn't make a living at it. --S. Jerrold Kaplan, one of the founders of Teknowledge Inc. ________________________________________________________________________________ ========================================================================= Date: Fri, 26 Feb 1993 16:34:31 -0800 Reply-To: robert@slipknot.rain.com Sender: "Microsoft Access Database Discussion List" From: robert@SLIPKNOT.RAIN.COM Subject: Re: Tab move sequence in Form. In-Reply-To: Your message of Fri, 26 Feb 93 18:47:21 -0500. NBRINDLE%INDYCMS.BITNET@pucc.Princeton.EDU writes: |Yes, go to the Edit menu while in Form Design and choose the last option, |Tab Order. That will bring up a dialog box that allows you to switch |things around. | |HOWEVER...one thing it do is let you leave something OUT of the |Tab order completely, such as a command button. Does anyone have any |ideas on how to accomplish that? I'm at a loss. I just did a little be of exploring that today, but I don't think you're going to like the answer. There appears to be two properties that remove a control from the tab order, but both have side effects: Visible does it, but makes the control invisible. Select also does it, but makes the control unselectable. So far I haven't found any other way. So, are other people coming to the conclusion that MS Access is a hodged together POS like I am? ________________________________________________________________________________ Robert Reed Home Animation Ltd. 503-656-8414 robert@slipknot.rain.com 5686 First Court, West Linn, OR 97068 I got a postcard from my friend George with a satellite picture of the entire earth. On the back he wrote, "Wish you were here." --Steve Wright ________________________________________________________________________________ ========================================================================= Date: Fri, 26 Feb 1993 17:04:22 PST Reply-To: "Microsoft Access Database Discussion List" Sender: "Microsoft Access Database Discussion List" From: "ROBERT GRINNELL, SEATTLE PACIFIC UNIVERSITY" Subject: Re: Tab move sequence in Form. In reply to message of Fri, 26 Feb 1993 18:47:21 EST from Nathan Brindle >HOWEVER...one thing it do is let you leave something OUT of the >Tab order completely, such as a command button. Does anyone have any >ideas on how to accomplish that? I'm at a loss. In Visual Basic, this is done by setting the TabStop property of a control to False. Finding this lacking in Access Basic, and noting that tab order is done in a dialog box where this is not an option (rather than with a TabIndex property), it looks like it is a point of flexibility that MS left out of Access, perhaps to keep it simpler for the non-programmer. Robert Grinnell Seattle Pacific University r_grinnell@luke.spu.edu ========================================================================= Date: Fri, 26 Feb 1993 17:17:07 PST Reply-To: "Microsoft Access Database Discussion List" Sender: "Microsoft Access Database Discussion List" From: "ROBERT GRINNELL, SEATTLE PACIFIC UNIVERSITY" Subject: Re: Tab move sequence in Form. In reply to message of Fri, 26 Feb 1993 18:47:21 EST from Nathan Brindle >>HOWEVER...one thing it do is let you leave something OUT of the >>Tab order completely, such as a command button. Does anyone have any >>ideas on how to accomplish that? I'm at a loss. >In Visual Basic, this is done by setting the TabStop property of a control to >False. Finding this lacking in Access Basic, and noting that tab order is >done in a dialog box where this is not an option (rather than with a TabIndex >property), it looks like it is a point of flexibility that MS left out of >Access, perhaps to keep it simpler for the non-programmer. In correction of my prior message, try setting the Enabled property to No for the control in question. This prevents it from having Focus, and should therefore keep it out of the Tab sequence. It is still visible, but grayed. Of course, this does mean it is disabled, but that is essentially what you mean if you are preventing the user from tabbing to it. Robert Grinnell Seattle Pacific University r_grinnell@luke.spu.edu ========================================================================= Date: Fri, 26 Feb 1993 20:29:07 EST Reply-To: "Microsoft Access Database Discussion List" Sender: "Microsoft Access Database Discussion List" From: "NATHAN BRINDLE" Subject: Re: Tab move sequence in Form. In-Reply-To: Message of Fri, 26 Feb 1993 17:17:07 PST from Unfortunately disabling it is not going to suit the purpose. I want to have a button that operates that isn't in the tab order. I guess I'll have to wait for the next version or try something that someone else suggested in private mail, that is, put the button in the header or footer of the form. -----------------------------------------------------BITNET: NBRINDLE@INDYCMS Nathan C. Brindle, Student Activities Office Indiana University Purdue University Indianapolis Staff Advisor, ALPHA PHI OMEGA, TAU OMICRON CHAPTER List Owner, STUACTS@INDYCMS, APOSEC52@INDYCMS, and ACCESS-L@INDYCMS Internet: NBRINDLE@INDYCMS.IUPUI.EDU or NBRINDLE@INDYVAX.IUPUI.EDU ------------------------------------------------------------------------------